package com.example.demo.Mappers;

import com.example.demo.beans.GetPacsInfoR;
import com.example.demo.beans.GetPacsMxTemBean;
import com.example.demo.beans.PacsTempBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created by Administrator on 2018-10-20.
 */
@Mapper
public interface PacsInfoMapper {
    @Select("select repId,repName,repType,repTime,repDeptId,repDeptName,repDoctId,repDoctName,checkDoctId,checkDoctName,status,reserved,patientName " +
            " from Auto_View_Pacs WHERE cardNo=#{cardNo} and repTime>=#{startDate} and repTime<=#{endDate} ")
    List<PacsTempBean> getTempPacsInfo(@Param("cardNo")String cardNo,@Param("startDate") String startDate,@Param("endDate") String endDate);
    @Select("select cardNo,repId,repName,repType,repTime,repDeptId,repDeptName,repDoctId,repDoctName,checkDoctId,checkDoctName,status,reserved,patientName " +
            " from Auto_View_Pacs WHERE repTime>=#{startDate} and repTime<=#{endDate} ")
    List<GetPacsInfoR> GetPacsInfo(@Param("startDate") String startDate, @Param("endDate") String endDate);

    @Select("select  itemCode,itemName,checkPart,repTime,diagnosis,discription, reserved    from  Auto_View_Pacsmx where PATIENTID=#{PATIENTID}" )
    GetPacsMxTemBean getPacsMxInfo(@Param("PATIENTID")String PATIENTID );

}
